﻿CREATE TABLE [dbo].[Address] (
    [AddressID]    UNIQUEIDENTIFIER NOT NULL,
    [CreatedDate]  DATETIME         NOT NULL,
    [CreatedBy]    UNIQUEIDENTIFIER NOT NULL,
    [ModifiedDate] DATETIME         NOT NULL,
    [ModifiedBy]   UNIQUEIDENTIFIER NOT NULL,
    [Deleted]      BIT              NOT NULL,
    [ProvinceID]   UNIQUEIDENTIFIER NOT NULL,
    [Line1]        VARCHAR (64)     NOT NULL,
    [Line2]        VARCHAR (64)     NOT NULL,
    [Suburb]       VARCHAR (64)     NOT NULL,
    [Code]         VARCHAR (12)     NOT NULL,
    [Longitude]    NUMERIC (18, 18) NOT NULL,
    [Latitude]     NUMERIC (18, 18) NOT NULL
);

